Skip to main content

Group Report

  • By using this document user can generate Group Report. With the help of the Group Report feature, users can send multiple reports in a single group and schedule them.

Group Report: This video contains information of Group Report in OPNBI

  • In this given Scenario according to the report Create/select the dataset. Both the dataset and report should contain the same column name with a unique value, then Select the format in which you want to download the report. schedule reports as per your required Frequency and then select the gbr format for the report and then run the report. Then your Group Report will be generated & you can download that group report from the report section. It will download a Zip file, which contains separate reports.

What is Group Report?

  • Group Report will generate a separate report for each entry in Dataset. The user can share the N number of Reports in a group when required. By Group Report feature users can send multiple reports in a single group.

  • Group Report will use in the condition when the user wants to send multiple reports in a group of one & schedule it as per their & another user's requirement. While generating & scheduling group reports they will set a unique column name as required & by which another user will see their report for that particular column name. Users can also share that generated report by email when it is required.

  • By generating a group report user will get a separate report based on a unique column name which is one of the most important points of this & they can schedule that generated report to another user based on time or event to save each of the user's time.

Use Case

  • Consider a scenario where the user wants to generate a group report by scheduling Customers details Report & for that generating that user needs the dataset having a matching column with a parameter which you are going to pass from the report.

Objectives

  • Generate Group Report

Prerequisites

  • For this example customers.ds & Customers details. Report with parameter is mandatory.

Download group_report.zip file from link given group_report.zip

  • Upload Customers details.rptdesign to Report & customers.ds to Dataset Section. Refer this link to see how to upload files in OPNBI. Use same procedure to upload both of the files.

Skill Level Required

  • No prior knowledge is required.

Select Dataset to generat Group Report

  • Dataset should have a matching column with a parameter that you are going to pass from the report.

  • Go to the Document Section > Report Section.

    Docusaurus Slash Introduction

  • Double click on the report which you are going to use while generating the group report.

  • For this example; we are using Customers details.rptdesign. So double click on Customers details.rptdesign & schedule report window will be shown as per below.

    Docusaurus Slash Introduction

  • By this parameter window, you will see that which parameter is passing from the report.

  • For Example; This report is passing the parameter name CUSTOMERNUMBER from the report, then that dataset should have the CUSTOMERNUMBER column in it.

  • After seeing which parameter is passing from the report, go to Master Data > Dataset section.

    Docusaurus Slash Introduction

  • You have to select a dataset according to which report you are going to use.

  • Edit the Dataset to see its column names.

  • For this example; we are using customers.ds so the user needs to edit this dataset.

  • Click here to see how to edit dataset.

  • Go to Output Columns of Edit Dataset & see where the Column name same as the parameter name which is passing through the report is available or not.

  • For this example we are using Customer details report & CUSTOMERNUMBER parameter are passing through it. So will check if column name CUSTOMERNUMBER is available in dataset customers or not.

    Docusaurus Slash Introduction

  • Dataset customers.ds have the column name & the parameter which are passing through the report are same 'CUSTOMERNUMBER'.

  • So we can use this dataset while generating the Group Report.

Steps to create Group Report

  1. log in to OPNBI with your credentials.

  2. Go to Hamburger menu Docusaurus Slash Introduction > Document Section > Group Report.

    Docusaurus Slash Introduction

  3. User will be able to see the Group Report window as below:

    Docusaurus Slash Introduction

  4. Fill in the details as given below:

  • Datasets: customers.ds

Docusaurus Slash Introduction

  1. If the selected dataset has the parameter passing through it then a window will ask for that parameter. Otherwise, it will show No Parameter Found as shown in the image above.

  2. Click on the Next button from the footer menu as shown in the image above.

  3. User will be able to see the window as shown below:

    Docusaurus Slash Introduction

  4. Fill in the details as per below:

I. Name

  • User needs to provide group name for the report here.

  • By this name group will be created & all the reports will be in that group.

  • For this example; we will give a name: Customer Group Report

II. Column Name

  • Column name should be unique.

  • By which all the files(report) will be created in the group.

  • For ths example; we will select CUSTOMERNUMBER from the drop-down.

III. Select Report

  • Select report which user wants to group.

  • User needs to select report with parameter (mendatory)

  • For this example; we will select Customers details.rptdesign report

IV. Format

  • This is the format in which the report will be created.

  • In this drop-down the report format will be displayed.

  • User can select the required format type from the proprty of the report. For that refer this Link

  • For this example; we will select rptdocument format

  1. When the user will click on the Browse option as shown, then the user will be able to see the window as below and they can select Report:

    Docusaurus Slash Introduction

  2. After filling in the required details, the user will see the window as shown in the image below:

    Docusaurus Slash Introduction

  3. The report parameter will be shown in blank space as shown above from which the user can map the dataset with it. In this example, we are mapping CUSTOMERNUMBER.

  4. Click on the Next button from the bottom. User will see the next window as shown:

    Docusaurus Slash Introduction

  5. From this window user can schedule the report as per the requirement.

Note
  1. For this example we schedule this report using Right Now.

  2. Click on the Next button from the bottom & user will see the next window as shown:

    Docusaurus Slash Introduction

  3. User can see the filled details in the image above, it will be filled by default.

Note
  • Refer this Link to know more about Output Tab.
Note
  • We are generating a group report in which a list of reports is available & it will be saved in gbr (kind of zip format) format in OPNBI.

  • When will download that gbr format file it will be downloaded in a zip in your system. & you will be able to see the list of the report while extracting that downloaded zip file.

  1. Users can make changes in filled details as per their requirements. They can change report name, suffix, format & path, etc...

  2. Click on the RUN button from the bottom.

  3. The Report will run & user will get a pop-up message of it on screen as below:

    Docusaurus Slash Introduction

  4. Now go to the Request Section from the Hamburger menu.

    Docusaurus Slash Introduction

  5. User will see the Request window as per below:

    Docusaurus Slash Introduction

Note
  1. Click on Customer Group Report as shown in the image above & report will be displayed with details as shown in the image below:

    Docusaurus Slash Introduction

  2. Now go to Hamburger Menu Docusaurus Slash Introduction > Document Section > Report Section.

    Docusaurus Slash Introduction

  3. In the Report Section go to Output Folder > Temp Folder.

  4. Here you can see the Customer Group Report. If you can't able to see that click on the Last Updated column & your latest created report will be shown at the top.

  5. Double Click on Customer Group Report & Enter Group Key (103) as shown in the image below:

    Docusaurus Slash Introduction

  6. Group Key will be the unique column name that you have selected.

  7. For this example; we have selected CUSTOMERNUMBER as Column Name then it is our group key for this report.

  8. Click on Submit button & it will redirect you to another tab of the browser.

  9. And your report will be displayed as shown in the image below:

    Docusaurus Slash Introduction